Error No: 1064 - MySQL error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 15
Query:
SELECT
COUNT(pt.picturetag_id)
FROM
picturetag pt
LEFT JOIN
picture p
ON
p.picture_id=pt.picture_id
LEFT JOIN
b_picture b
ON
b.b_picture_id=pt.b_picture_id
WHERE
pt.tag_id=
#0 /var/www/tip4.boeren.nu/public_html/classes/class.picturetag.php(44): Mysql->execute('\n SE...', 2)
#1 /var/www/tip4.boeren.nu/public_html/controllers/show.php(168): PictureTag->getTotalPictures(NULL)
#2 /var/www/tip4.boeren.nu/public_html/controllers/show.php(5584): Show->tag_pictures()
#3 /var/www/tip4.boeren.nu/public_html/controllers/show.php(5597): Show->__construct(Object(mysqli))
#4 /var/www/tip4.boeren.nu/public_html/index.php(15): include_once('/var/www/tip4.b...')
#5 {main}Error No: 1064 - MySQL error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY
pt.picturetag_id DESC
LIMIT 12' at line 23
Query:
SELECT
pt.*,
p.merknaam,
p.typenaam,
p.location as t_location,
b.location as b_location,
p.flag_deleted as t_deleted,
b.flag_deleted as b_deleted,
p.no_picturecomments,
b.no_b_picturecomments
FROM
picturetag pt
LEFT JOIN
picture p
ON
p.picture_id=pt.picture_id
LEFT JOIN
b_picture b
ON
b.b_picture_id=pt.b_picture_id
WHERE
pt.tag_id=
ORDER BY
pt.picturetag_id DESC
LIMIT 12
#0 /var/www/tip4.boeren.nu/public_html/classes/class.picturetag.php(74): Mysql->execute('\n SE...')
#1 /var/www/tip4.boeren.nu/public_html/controllers/show.php(197): PictureTag->getPictures(NULL, 0)
#2 /var/www/tip4.boeren.nu/public_html/controllers/show.php(5584): Show->tag_pictures()
#3 /var/www/tip4.boeren.nu/public_html/controllers/show.php(5597): Show->__construct(Object(mysqli))
#4 /var/www/tip4.boeren.nu/public_html/index.php(15): include_once('/var/www/tip4.b...')
#5 {main}Error No: 1064 - MySQL error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND t.tag_id <> Tag.tag_id
GROUP BY
Tag.name' at line 15
Query:
SELECT
Tag.tag_id,
Tag.name,
Tag.slug,
Tag.no_b_pictures,
COUNT(*) as count
FROM
tag AS t
INNER JOIN picturetag AS pt ON (pt.tag_id = t.tag_id)
INNER JOIN b_picture AS bp ON (bp.b_picture_id = pt.b_picture_id AND bp.flag_deleted = 0)
INNER JOIN picturetag AS pota ON (pt.b_picture_id = pota.b_picture_id)
INNER JOIN tag AS Tag ON (pota.tag_id = Tag.tag_id)
WHERE
t.tag_id =
AND t.tag_id <> Tag.tag_id
GROUP BY
Tag.name
#0 /var/www/tip4.boeren.nu/public_html/classes/class.picturetag.php(94): Mysql->execute('SELECT\n ...')
#1 /var/www/tip4.boeren.nu/public_html/controllers/show.php(198): PictureTag->getRelated(NULL)
#2 /var/www/tip4.boeren.nu/public_html/controllers/show.php(5584): Show->tag_pictures()
#3 /var/www/tip4.boeren.nu/public_html/controllers/show.php(5597): Show->__construct(Object(mysqli))
#4 /var/www/tip4.boeren.nu/public_html/index.php(15): include_once('/var/www/tip4.b...')
#5 {main}
Warning: usort() expects parameter 1 to be array, boolean given in /var/www/tip4.boeren.nu/public_html/controllers/show.php on line 202
Warning: array_slice() expects parameter 1 to be array, boolean given in /var/www/tip4.boeren.nu/public_html/controllers/show.php on line 204
foto's
foto's m.b.t. , een van de 9782 onderwerpen op Boeren.online. Deze foto's zijn geplaatst door de leden van Boeren.online en TractorFan.nl